Data Analytics MasterClass (PostgreSQL, BI, Python)

Subject Included:

1. PostgreSQL for Beginners
2. PowerBI MasterClass
3. QlikView Dashboard Design MasterClass
4. Qlik Sense for Beginners
5. Python for Beginners

• PostgreSQL for Beginners 1:06:48

  • 1: PostgreSQL for Beginners: Introduction Preview 00:10
  • 2: Introduction Preview 03:00
  • 3: What is PostgreSQL? 03:43
  • 4: PostgreSQL Installation Preview 06:32
  • 5: PostgreSQL for Beginners: Create, Modify & Delete Table 00:10
  • 6: Creating Tables 05:29
  • 7: Alter Tables 13:29
  • 8: Copying CSV Records into Table 04:42
  • 9: PostgreSQL for Beginners : SQL Commands 00:10
  • 10: Select Statement 03:21
  • 11: Where Statements - Text, Numeric & Date columns 04:18
  • 12: Where Statements - Dynamic, And/Or filters 06:16
  • 13: Where Statement - Wildcards 04:25
  • 14: Order By Statement 02:21
  • 15: Sum 05:21
  • 16: Select Distinct 02:16
  • 17: PostgreSQL for Beginners : Conclusion 01:05

• PowerBI MasterClass 2:48:53

  • 18: PowerBI MasterClass : Introduction 00:10
  • 19: Introduction Preview 02:35
  • 20: Table of Content Preview 01:57
  • 21: Introduction to BI Preview 02:08
  • 22: Installing PowerBI Desktop 01:18
  • 23: Loading Data into PowerBI 02:41
  • 24: Creating Our first Dashboard(Slicer, Card, Donut) 05:34
  • 25: Creating Our First Dashboard(Table and Bar) 03:22
  • 26: Challenge 00:41
  • 27: Solution 02:07
  • 28: Creating Measure 01:28
  • 29: Creating Measure in Excel 02:22
  • 30: DataTypes 03:17
  • 31: Creating Measure in PowerBI 03:43
  • 32: Sorting 03:49
  • 33: Sorting : Demo 06:23
  • 34: Calendar 01:44
  • 35: DAX 05:07
  • 36: Chart Interaction 02:40
  • 37: Creating Buttons 03:28
  • 38: Creating Variables 05:18
  • 39: Creating Bookmarks 03:08
  • 40: PowerBI MasterClass : Introduction to PowerQuery 00:10
  • 41: Introduction to PowerQuery Preview 03:22
  • 42: 20.Connecting Data From Web 03:51
  • 43: Changing Data Type 03:07
  • 44: Column Splitting 04:53
  • 45: Formatting 03:18
  • 46: Extract 02:15
  • 47: Statistical Information from PowerQuery 04:37
  • 48: Alternative to Transform Column 01:30
  • 49: Custom Column 04:10
  • 50: Conditional Column 02:22
  • 51: Index & Duplicated Columns 03:43
  • 52: Add Column Format & Extract 02:43
  • 53: Challenge 2 03:08
  • 54: Solution 2 06:59
  • 55: PowerBI Report: Visual, Measure, and DAX 00:10
  • 56: Master Calendar 03:22
  • 57: Table Matrix 04:23
  • 58: Variable 05:18
  • 59: MTD Logic 08:16
  • 60: MTD Logic : Advanced Filtering 05:17
  • 61: Challenge 3 00:58
  • 62: Solution 3 04:57
  • 63: Prior Month & Prior Year 08:17
  • 64: Buttons 08:28
  • 65: Color Codes 03:00
  • 66: PowerBI MasterClass : Conclusion 01:19

• QlikView Dashboard Design MasterClass 2:27:21

  • 67: QlikView MasterClass : HR Dashboard 00:10
  • 68: Introduction Preview 01:42
  • 69: Data Study Preview 03:53
  • 70: Extracting Dataset Preview 05:14
  • 71: Forecast Logic Preview 09:28
  • 72: Dashboard Title 03:48
  • 73: KPI Objects 08:32
  • 74: Forecast Demo 03:27
  • 75: Net Pay KPI 05:24
  • 76: Forecast vs Actual (%) 07:57
  • 77: Donut & Block Chart 06:47
  • 78: Bar Chart by Quarter by Region 04:41
  • 79: Class Groupings 06:57
  • 80: Conclusion 01:18
  • 81: QlikView MasterClass : Opening A Food Restaurant 00:10
  • 82: Introduction Preview 04:14
  • 83: Data Walkthrough 02:38
  • 84: Lines, Page Separator 07:08
  • 85: KPI Boxes 08:43
  • 86: Main Course & Dish 07:10
  • 87: Scatter Plot - Calories vs Price 06:21
  • 88: Dine In Reason & Conclusion 04:50
  • 89: QlikView MasterClass : Sales Dashboard 00:10
  • 90: Logo and Title 04:52
  • 91: KPI Box 11:14
  • 92: Block Chart 04:51
  • 93: Sales vs Target Line Chart 05:49
  • 94: Sales Composition By Product Category Preview 08:44
  • 95: 34_Conclusion_Final-converted 01:09

• Qlik Sense For Beginners 1:07:42

  • 96: Qlik Sense for Beginners : Introduction 00:10
  • 97: Introduction 02:59
  • 98: Introduction : What is BI? Preview 02:45
  • 99: Loading Data into Qlik Sense 06:02
  • 100: Introduction : Qlik Sense Workflow 04:43
  • 101: Qlik Sense for Beginners : Creating Our First Dashboard 00:10
  • 102: Creating Our First Dashboard 06:57
  • 103: Introduction : Adding new Columns 01:15
  • 104: Adding New Columns into Table 07:05
  • 105: Introduction : Sorting 01:37
  • 106: Sorting in Table 05:07
  • 107: Introduction : Chart Interactions 01:31
  • 108: Chart Interaction in Qlik Sense 06:11
  • 109: Table Linkage 07:13
  • 110: Creating Bookmarks 03:12
  • 111: Creating Buttons 05:46
  • 112: Qlik Sense For Beginners : Conclusion 04:59

• Python for Beginners 1:19:23

  • 113: Python for Beginners : Introduction 00:10
  • 114: Welcome Aboard! 03:25
  • 115: What is Python? 04:52
  • 116: Downloading and Installing Python 03:42
  • 117: Python for Beginners : Function, Class & Data Structures 00:10
  • 118: Creating a New ipynb file 03:56
  • 119: Defining Functions 04:07
  • 120: Extending Functions with Keyword Arguments 05:34
  • 121: Class Objects 04:27
  • 122: List 04:55
  • 123: List - Append vs Extend 04:23
  • 124: Numeric List 06:58
  • 125: Dictionary 04:55
  • 126: Converting List to Dictionary 03:20
  • 127: Python for Beginners : Introduction to Python Pandas 00:10
  • 128: Importing Pandas 04:07
  • 129: Removing Columns 03:50
  • 130: Column Transformation 04:47
  • 131: Row Transformation : Apply Lambda 06:27
  • 132: Groupby : Agg 03:45
  • 133: Python for Beginners : Conclusion 01:23

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, and worksheets), or unstructured data (free text fields or comments from social media).

An example of Data Usage is in AI model.

Data are the core of an AI model, which utilizes data input for the model to train, test, and learn from the data.

The usage of Machine Learning has allowed computers to perform predictions and provides suggestions to humans based on the data input that has been fed into the machine.

An example of Machine Learning is the Web Search Engine, which tries to understand what is the content we are searching for based on the data input that has been entered into the Search Engine.

This course offers everyone an abundance of information about analytical tools that may help you in developing your career moving forward.

Content in this course is as below:

Database

1. PostgreSQL For Beginners

Learning Outcomes:

~How to install and configure PostgreSQL.

~How to create and modify tables in PostgreSQL.

~How to perform basic SQL commands in PostgreSQL.

BI (Business Intelligence)

2. PowerBI MasterClass

Learning Outcomes:

~How to transform our columns to extract values or change column formatting

~How to add new columns, eg: Custom columns, conditional columns, index columns, etc.

~DAX expressions

3. QlikView Dashboard Design MasterClass

Learning Outcomes:

How to build a simple dashboard:

~ HR Dashboard

~Opening a Fast Food Restaurant

~Sales Dashboard

4. Qlik Sense for Beginners

Imagine if we are recently appointed to be a director of an organization, are we able to:

1. React based on the latest or historical information around us?

2. Reduce or automate the manual work done in decades?

3. Draw insights from a stack of printed reports?

If you do not have the answer, join this class to know more about Qlik Sense which can help solve your problems.

Advanced Analytics

5. Python for Beginners

Learning Outcomes:

1. Python Function and Class Objects.

2. Data Types - String and Numeric.

3. Python Data Structure - List and Data Dictionary.

This course is suitable for anyone who is interested in pursuing the following professions:

1. BI Analyst
2. Business Analyst
3. Fresh Graduate in IT
4. Database Administrator
5. Data Analytics Beginner
6. Business Intelligence Beginner
7. Python Beginners who are curious about Data Science

Suitable for all levels

This course is suitable for anyone who is interested in pursuing the following professions:

1. BI Analyst
2. Business Analyst
3. Fresh Graduate in IT
4. Database Administrator
5. Data Analytics Beginner
6. Business Intelligence Beginner
7. Python Beginners who are curious about Data Science

Currently there are no Q&As for this course. Be the first to ask a question.

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included